﻿CREATE TABLE [dbo].[Person] (
    [Id]             UNIQUEIDENTIFIER NOT NULL,
    [ValId]          UNIQUEIDENTIFIER NOT NULL,
    [Skapad]         DATETIME         NOT NULL,
    [SkapadAv]       NVARCHAR (50)    NOT NULL,
    [Andrad]         DATETIME         NULL,
    [AndradAv]       NVARCHAR (50)    NULL,
    [Personnummer]   NVARCHAR (50)    NOT NULL,
    [Fornamn]        NVARCHAR (255)   NULL,
    [Efternamn]      NVARCHAR (255)   NULL,
    [TelNr]          NVARCHAR (255)   NULL,
    [MobTelNr]       NVARCHAR (255)   NULL,
    [Epost]          NVARCHAR (255)   NULL,
    [Gatuadress]     NVARCHAR (255)   NULL,
    [PostNr]         NVARCHAR (255)   NULL,
    [PostOrt]        NVARCHAR (255)   NULL,
    [Inaktiv]        BIT              NOT NULL,
    [AnmalanGodkand] BIT              NOT NULL,
    [AnsokanGodkand] BIT              NOT NULL,
    [Fritext]        TEXT             NULL,
    CONSTRAINT [PK_Person] PRIMARY KEY CLUSTERED ([Id] ASC, [ValId] ASC)
);













